Model Table ACTUAL START DATE

Attributes

AttributeDescription (where applicable)
Actual Start DateDate
Actual Start Date StringDate as string, fixed format, not NLS dependent
Actual Start MonthName of Month, NLS dependent
Actual Start Month NoMonth Number
Actual Start Month ShortMonth short, 3 char, NLS dependent
Actual Start QuarterQuarter, not NLS dependent
Actual Start WeekdayWeek Day
Actual Start Weekday NoWeek Day Number
Actual Start YearYear, NLS dependent
Actual Start Year MonthYear month
Current Month FlagCurrent month flag, day in current month
Current Year FlagCurrent year flag, day in current yea
Last 12 Months FlagLast 12 months flag, day between curr month-1 and curr month-12
Last 24 Months FlagLast24 months flag, day between curr month-24 and curr month-1
Year (Week based)Year, NLS dependent
Actual Start Week NoWeek Number

Hierarchies

HierarchyLevel
ActualStartMSHy
Actual Start Year
Actual Start Quarter
Actual Start Month
ActualStartMFHy
Actual Start Year
Actual Start Quarter
Actual Start Month
Actual Start Date
ActualStartWSHy
Actual Start Year
Actual Start Week No
ActualStartWFHy
Actual Start Year
Actual Start Week No
Actual Start Date

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
ACTUAL START DATEDIM_BI_TIME_TMDIM_BI_TIME_BIDIM_BI_TIMEOn Line